home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vsurvdetail.sql < prev    next >
Text File  |  2000-05-12  |  1KB  |  30 lines
  1.  
  2. CREATE OR REPLACE VIEW VSURVDETAIL AS SELECT TRUNC(DRIVER_CONTEXT.rte_date) survey_day,
  3. bus_id,  FAREENTR.fare_id,  FAREENTR.conv_date,
  4. FARETABLE.passengers,
  5. TRIPS.route_desc,
  6. RPTFAREMAP.rptclass, 
  7. RPTNAMES.SHORT_NAME
  8. FROM FARE_CONTEXT, DRIVER_CONTEXT, OPERATOR_CONTEXT, TRIPS, BUS, FAREBOX, FAREENTR,
  9. FARETABLE, FARECLASSES,  RPTFAREMAP , RPTNAMES  /*, vrpt12headers  */
  10. WHERE
  11. TRIPS.id = DRIVER_CONTEXT.trip_id AND
  12. TRIPS.runid = DRIVER_CONTEXT.run_id AND
  13. TRIPS.routeid = DRIVER_CONTEXT.route_id AND
  14. FARE_CONTEXT.driver_context_id = DRIVER_CONTEXT.driver_context_id AND
  15. DRIVER_CONTEXT.op_context_id = OPERATOR_CONTEXT.op_context_id AND
  16. OPERATOR_CONTEXT.CONFIG_NUM = TRIPS.CONFIG_NUM AND 
  17. FARE_CONTEXT.fare_context_id = FAREENTR.fare_context_id  AND
  18. OPERATOR_CONTEXT.farebox_glid = FAREBOX.glid AND
  19. BUS.glid = FAREBOX.location AND
  20. FARETABLE.fareset = FARE_CONTEXT.fareset_id AND
  21. FARETABLE.fare = FAREENTR.fare_id AND
  22. FARETABLE.config_num = OPERATOR_CONTEXT.config_num AND
  23. FARETABLE.class_num = FARECLASSES.class_num AND
  24. FARETABLE.config_num = FARECLASSES.config_num   AND
  25. RPTFAREMAP.fareset_id = FARE_CONTEXT.fareset_id AND
  26. RPTFAREMAP.fare_id = FARETABLE.fare AND
  27. RPTFAREMAP.config_num = FARECLASSES.config_num AND
  28. RPTFAREMAP.REPORT_INDX = RPTNAMES.REPORT_INDX AND 
  29. RPTNAMES.SHORT_NAME = 'SURVDET';
  30.